Share via

How to sql dump generation on sql server 2008 ?

Tidiane TRAORE 0 Reputation points
2024-05-13T16:40:04.5466667+00:00

Good morning,

I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory.

Can you give me the procedure to disable the generation of these files please.

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChenMSFT-4874 1,430 Reputation points
    2024-05-14T06:04:10.5133333+00:00

    Hi @Tidiane TRAORE,

    Thanks for your information.

    • We need to figure out from the ERRORLOG file the cause of the dump. Sometimes dumps are also generated because of Database corruption, I suggest you run DBCC CHECKDB. We can get the information from this article.

    If the output from DBCC CHECKDB indicates corruption in your indexes, rebuild them. If it indicates that “repair_allow_data_loss” is the minimum necessary to repair the database, then restore from last known good backup, when checkdb was clean.

    • What version of your SQL Server? Make sure you have applied the latest service pack and a cumulative update of SQL Server. I suggest go ahead and first apply SQL Server 2008 R2 SP3, GDR for SP3.
    • If you are lazy and not interested to know the cause, go ahead and delete the files. You should write a batch file to delete them on a regular basis.

    If you have any concerns, please feel free to share with us.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

  2. Erland Sommarskog 102.4K Reputation points
    2024-05-14T20:52:20.0033333+00:00

    So you are on the last service pack for SQL Server 2008 R2. You may be missing a few GDRs but it is unlikely that they will address the dumps you are seeing.

    Had you been on a supported version of SQL Server, I would have suggested that you open a support case, since dumps are often tokens of bugs in the product.

    At this stage, maybe the best way to get rid of the dumps to upgrade to SQL 2022, but, yes, it comes with a price tag. (Unless you can migrate to Express Edition.)

    To get rid of these dumps, you would need to take a closer look to understand the nature of them, and then try to connect to something in your workload that may be provoking the issue. These dump files are usually quite large, and not easy to read. But I would expect that there are shorter versions of them in the SQL Server errorlog.

    0 comments
  3. Tidiane TRAORE 0 Reputation points
    2024-05-22T10:57:38.6533333+00:00

    Ok I will open a support case.

    Thanks to all.